CREATE DATABASE ACADEMY_DB
GO

USE ACADEMY_DB
GO

CREATE TABLE subject_master
(
	idcode int identity(1,1) primary key,
	row_item_num int default 1,	
	uniquenum_pri varchar(50),
	uniquenum_sec varchar(50),
	uniquenum_uniq varchar(50),
	uniquenum_cnt int,
	dnum_auto varchar(50),
	dnum_reference varchar(50),
	dnum_master varchar(50),
	subject_unique varchar(50),
	subject_code varchar(50),	
	subject_desc_english nvarchar(max),
	subject_desc_vietnamese nvarchar(max),
	subject_desc_japanese nvarchar(max),
	subject_desc_chinese nvarchar(max),
	subject_desc_korean nvarchar(max),
	subject_desc_french nvarchar(max),
	subject_desc_german nvarchar(max),
	subject_desc_spanish nvarchar(max),
	subject_desc_lang01 nvarchar(max),
	subject_desc_lang02 nvarchar(max),
	subject_desc_lang03 nvarchar(max),
	subject_desc_memo nvarchar(max),
	notes_short nvarchar(500),	
	tag_deleted_yn varchar(5) default 'n',
	tag_table_usage varchar(50) default 'sys',
	tag_tab_type varchar(50),
	tag_subject_type varchar(50),
	tag_datasource varchar(500),
	notes_memo nvarchar(max),
	subjectgrp_unique varchar(50),
	subjectgrp_code varchar(50),
	subjectgrp_desc nvarchar(200),
	subjectcate_unique varchar(50),
	subjectcate_code varchar(50),
	subjectcate_desc nvarchar(200),
	subjectclas_unique varchar(50),
	subjectclas_code varchar(50),
	subjectclas_desc nvarchar(200),
	party_unique varchar(50),
	party_code varchar(50),
	party_desc nvarchar(200),
	author_unique varchar(50),
	author_code varchar(50),
	author_desc nvarchar(200),
	dnum_image01 varchar(50),
	dnum_image02 varchar(50),
	dnum_image03 varchar(50),
	dnum_image04 varchar(50),
	dnum_image05 varchar(50),
	dnum_catelog01 varchar(50),
	dnum_catelog02 varchar(50),
	dnum_catelog03 varchar(50),
	dnum_catelog04 varchar(50),
	dnum_catelog05 varchar(50),
	tag_others01 varchar(50) default 'na',
	tag_others02 varchar(50) default 'na',
	tag_others03 varchar(50) default 'na',
	tag_others04 varchar(50) default 'na',
	tag_others05 varchar(50) default 'na',
	tag_nnnn_yn01 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn02 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn03 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn04 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn05 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	var_50_001 varchar(50),
	var_50_002 varchar(50),
	var_50_003 varchar(50),
	var_50_004 varchar(50),
	var_50_005 varchar(50),
	var_50_006 varchar(50),
	var_50_007 varchar(50),
	var_50_008 varchar(50),
	var_50_009 varchar(50),
	var_50_010 varchar(50),
	var_200_001 varchar(200),
	var_200_002 varchar(200),
	var_200_003 varchar(200),
	var_200_004 varchar(200),
	var_200_005 varchar(200),
	num_20_4_d_001 numeric(20,4) default 0,
	num_20_4_d_002 numeric(20,4) default 0,
	num_20_4_d_003 numeric(20,4) default 0,
	num_20_4_d_004 numeric(20,4) default 0,
	num_20_4_d_005 numeric(20,4) default 0,
	num_20_4_d_006 numeric(20,4) default 0,
	num_20_4_d_007 numeric(20,4) default 0,
	num_20_4_d_008 numeric(20,4) default 0,
	num_20_8_d_001 numeric(20,8) default 0,
	num_20_8_d_002 numeric(20,8) default 0,
	num_20_8_d_003 numeric(20,8) default 0,
	num_20_8_d_004 numeric(20,8) default 0,
	num_20_8_d_005 numeric(20,8) default 0,
	num_20_8_d_006 numeric(20,8) default 0,
	num_20_8_d_007 numeric(20,8) default 0,
	num_20_8_d_008 numeric(20,8) default 0,
	date_001 datetime,
	date_002 datetime,
	date_003 datetime,
	date_004 datetime,
	date_005 datetime,
	date_006 datetime,
	date_007 datetime,
	date_008 datetime,
	date_009 datetime,
	date_010 datetime,
	date_post datetime default GETDATE(),
	date_lastupdate datetime default GETDATE(),
	date_submit datetime,
	tag_void_yn varchar(5) default 'n',
	tag_active_yn varchar(5) default 'y',
	userid_cookie varchar(50)
)
GO

CREATE TABLE subject_main
(
	idcode int identity(1,1) primary key,
	row_item_num int default 1,	
	uniquenum_pri varchar(50),
	uniquenum_sec varchar(50),
	uniquenum_uniq varchar(50),
	uniquenum_cnt int,
	dnum_auto varchar(50),
	dnum_reference varchar(50),
	dnum_master varchar(50),
	subjectmain_unique varchar(50),
	subjectmain_code varchar(50),	
	subjectmain_desc_english nvarchar(max),
	subjectmain_desc_vietnamese nvarchar(max),
	subject_desc_japanese nvarchar(max),
	subjectmain_desc_chinese nvarchar(max),
	subjectmain_desc_korean nvarchar(max),
	subjectmain_desc_french nvarchar(max),
	subjectmain_desc_german nvarchar(max),
	subjectmain_desc_spanish nvarchar(max),
	subjectmain_desc_lang01 nvarchar(max),
	subjectmain_desc_lang02 nvarchar(max),
	subjectmain_desc_lang03 nvarchar(max),
	subjectmain_desc_memo nvarchar(max),
	notes_short nvarchar(500),	
	tag_deleted_yn varchar(5) default 'n',
	tag_table_usage varchar(50) default 'sys',
	tag_tab_type varchar(50),
	tag_subjectmain_type varchar(50),
	tag_datasource varchar(500),
	notes_memo nvarchar(max),
	subjectmaingrp_unique varchar(50),
	subjectmaingrp_code varchar(50),
	subjectmaingrp_desc nvarchar(200),
	subjectmaincate_unique varchar(50),
	subjectmaincate_code varchar(50),
	subjectmaincate_desc nvarchar(200),
	subjectmainclas_unique varchar(50),
	subjectmainclas_code varchar(50),
	subjectmainclas_desc nvarchar(200),
	party_unique varchar(50),
	party_code varchar(50),
	party_desc nvarchar(200),
	author_unique varchar(50),
	author_code varchar(50),
	author_desc nvarchar(200),
	dnum_image01 varchar(50),
	dnum_image02 varchar(50),
	dnum_image03 varchar(50),
	dnum_image04 varchar(50),
	dnum_image05 varchar(50),
	dnum_catelog01 varchar(50),
	dnum_catelog02 varchar(50),
	dnum_catelog03 varchar(50),
	dnum_catelog04 varchar(50),
	dnum_catelog05 varchar(50),
	tag_others01 varchar(50) default 'na',
	tag_others02 varchar(50) default 'na',
	tag_others03 varchar(50) default 'na',
	tag_others04 varchar(50) default 'na',
	tag_others05 varchar(50) default 'na',
	tag_nnnn_yn01 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn02 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn03 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn04 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn05 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	var_50_001 varchar(50),
	var_50_002 varchar(50),
	var_50_003 varchar(50),
	var_50_004 varchar(50),
	var_50_005 varchar(50),
	var_50_006 varchar(50),
	var_50_007 varchar(50),
	var_50_008 varchar(50),
	var_50_009 varchar(50),
	var_50_010 varchar(50),
	var_200_001 varchar(200),
	var_200_002 varchar(200),
	var_200_003 varchar(200),
	var_200_004 varchar(200),
	var_200_005 varchar(200),
	num_20_4_d_001 numeric(20,4) default 0,
	num_20_4_d_002 numeric(20,4) default 0,
	num_20_4_d_003 numeric(20,4) default 0,
	num_20_4_d_004 numeric(20,4) default 0,
	num_20_4_d_005 numeric(20,4) default 0,
	num_20_4_d_006 numeric(20,4) default 0,
	num_20_4_d_007 numeric(20,4) default 0,
	num_20_4_d_008 numeric(20,4) default 0,
	num_20_8_d_001 numeric(20,8) default 0,
	num_20_8_d_002 numeric(20,8) default 0,
	num_20_8_d_003 numeric(20,8) default 0,
	num_20_8_d_004 numeric(20,8) default 0,
	num_20_8_d_005 numeric(20,8) default 0,
	num_20_8_d_006 numeric(20,8) default 0,
	num_20_8_d_007 numeric(20,8) default 0,
	num_20_8_d_008 numeric(20,8) default 0,
	date_001 datetime,
	date_002 datetime,
	date_003 datetime,
	date_004 datetime,
	date_005 datetime,
	date_006 datetime,
	date_007 datetime,
	date_008 datetime,
	date_009 datetime,
	date_010 datetime,
	date_post datetime default GETDATE(),
	date_lastupdate datetime default GETDATE(),
	date_submit datetime,
	tag_void_yn varchar(5) default 'n',
	tag_active_yn varchar(5) default 'y',
	userid_cookie varchar(50)
)
GO

CREATE TABLE subject_data
(
	idcode int identity(1,1) primary key,
	row_item_num int default 1,	
	uniquenum_pri varchar(50),
	uniquenum_sec varchar(50),
	uniquenum_uniq varchar(50),
	uniquenum_cnt int,
	dnum_auto varchar(50),
	dnum_reference varchar(50),
	dnum_master varchar(50),
	subjectdata_unique varchar(50),
	subjectdata_code varchar(50),	
	subjectdata_desc_english nvarchar(max),
	subjectdata_desc_vietnamese nvarchar(max),
	subjectdata_desc_japanese nvarchar(max),
	subjectdata_desc_chinese nvarchar(max),
	subjectdata_desc_korean nvarchar(max),
	subjectdata_desc_french nvarchar(max),
	subjectdata_desc_german nvarchar(max),
	subjectdata_desc_spanish nvarchar(max),
	subjectdata_desc_lang01 nvarchar(max),
	subjectdata_desc_lang02 nvarchar(max),
	subjectdata_desc_lang03 nvarchar(max),
	subjectdata_desc_memo nvarchar(max),
	notes_short nvarchar(500),	
	tag_deleted_yn varchar(5) default 'n',
	tag_table_usage varchar(50) default 'sys',
	tag_tab_type varchar(50),
	tag_subjectdata_type varchar(50),
	tag_datasource varchar(500),
	notes_memo nvarchar(max),
	subjectdatagrp_unique varchar(50),
	subjectdatagrp_code varchar(50),
	subjectdatagrp_desc nvarchar(200),
	subjectdatacate_unique varchar(50),
	subjectdatacate_code varchar(50),
	subjectdatacate_desc nvarchar(200),
	subjectdataclas_unique varchar(50),
	subjectdataclas_code varchar(50),
	subjectdataclas_desc nvarchar(200),
	party_unique varchar(50),
	party_code varchar(50),
	party_desc nvarchar(200),
	author_unique varchar(50),
	author_code varchar(50),
	author_desc nvarchar(200),
	dnum_image01 varchar(50),
	dnum_image02 varchar(50),
	dnum_image03 varchar(50),
	dnum_image04 varchar(50),
	dnum_image05 varchar(50),
	dnum_catelog01 varchar(50),
	dnum_catelog02 varchar(50),
	dnum_catelog03 varchar(50),
	dnum_catelog04 varchar(50),
	dnum_catelog05 varchar(50),
	tag_others01 varchar(50) default 'na',
	tag_others02 varchar(50) default 'na',
	tag_others03 varchar(50) default 'na',
	tag_others04 varchar(50) default 'na',
	tag_others05 varchar(50) default 'na',
	tag_nnnn_yn01 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn02 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn03 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn04 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn05 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	var_50_001 varchar(50),
	var_50_002 varchar(50),
	var_50_003 varchar(50),
	var_50_004 varchar(50),
	var_50_005 varchar(50),
	var_50_006 varchar(50),
	var_50_007 varchar(50),
	var_50_008 varchar(50),
	var_50_009 varchar(50),
	var_50_010 varchar(50),
	var_200_001 varchar(200),
	var_200_002 varchar(200),
	var_200_003 varchar(200),
	var_200_004 varchar(200),
	var_200_005 varchar(200),
	num_20_4_d_001 numeric(20,4) default 0,
	num_20_4_d_002 numeric(20,4) default 0,
	num_20_4_d_003 numeric(20,4) default 0,
	num_20_4_d_004 numeric(20,4) default 0,
	num_20_4_d_005 numeric(20,4) default 0,
	num_20_4_d_006 numeric(20,4) default 0,
	num_20_4_d_007 numeric(20,4) default 0,
	num_20_4_d_008 numeric(20,4) default 0,
	num_20_8_d_001 numeric(20,8) default 0,
	num_20_8_d_002 numeric(20,8) default 0,
	num_20_8_d_003 numeric(20,8) default 0,
	num_20_8_d_004 numeric(20,8) default 0,
	num_20_8_d_005 numeric(20,8) default 0,
	num_20_8_d_006 numeric(20,8) default 0,
	num_20_8_d_007 numeric(20,8) default 0,
	num_20_8_d_008 numeric(20,8) default 0,
	date_001 datetime,
	date_002 datetime,
	date_003 datetime,
	date_004 datetime,
	date_005 datetime,
	date_006 datetime,
	date_007 datetime,
	date_008 datetime,
	date_009 datetime,
	date_010 datetime,
	date_post datetime default GETDATE(),
	date_lastupdate datetime default GETDATE(),
	date_submit datetime,
	tag_void_yn varchar(5) default 'n',
	tag_active_yn varchar(5) default 'y',
	userid_cookie varchar(50)
)
GO

CREATE TABLE subject_body
(
	idcode int identity(1,1) primary key,
	row_item_num int default 1,	
	uniquenum_pri varchar(50),
	uniquenum_sec varchar(50),
	uniquenum_uniq varchar(50),
	uniquenum_cnt int,
	dnum_auto varchar(50),
	dnum_reference varchar(50),
	dnum_master varchar(50),
	subjectbody_unique varchar(50),
	subjectbody_code varchar(50),	
	subjectbody_desc_english nvarchar(max),
	subjectbody_desc_vietnamese nvarchar(max),
	subjectbody_desc_japanese nvarchar(max),
	subjectbody_desc_chinese nvarchar(max),
	subjectbody_desc_korean nvarchar(max),
	subjectbody_desc_french nvarchar(max),
	subjectbody_desc_german nvarchar(max),
	subjectbody_desc_spanish nvarchar(max),
	subjectbody_desc_lang01 nvarchar(max),
	subjectbody_desc_lang02 nvarchar(max),
	subjectbody_desc_lang03 nvarchar(max),
	subjectbody_desc_memo nvarchar(max),
	notes_short nvarchar(500),	
	tag_deleted_yn varchar(5) default 'n',
	tag_table_usage varchar(50) default 'sys',
	tag_tab_type varchar(50),
	tag_subjectbody_type varchar(50),
	tag_datasource varchar(500),
	notes_memo nvarchar(max),
	subjectbodygrp_unique varchar(50),
	subjectbodygrp_code varchar(50),
	subjectbodygrp_desc nvarchar(200),
	subjectbodycate_unique varchar(50),
	subjectbodycate_code varchar(50),
	subjectbodycate_desc nvarchar(200),
	subjectbodyclas_unique varchar(50),
	subjectbodyclas_code varchar(50),
	subjectbodyclas_desc nvarchar(200),
	party_unique varchar(50),
	party_code varchar(50),
	party_desc nvarchar(200),
	author_unique varchar(50),
	author_code varchar(50),
	author_desc nvarchar(200),
	dnum_image01 varchar(50),
	dnum_image02 varchar(50),
	dnum_image03 varchar(50),
	dnum_image04 varchar(50),
	dnum_image05 varchar(50),
	dnum_catelog01 varchar(50),
	dnum_catelog02 varchar(50),
	dnum_catelog03 varchar(50),
	dnum_catelog04 varchar(50),
	dnum_catelog05 varchar(50),
	tag_others01 varchar(50) default 'na',
	tag_others02 varchar(50) default 'na',
	tag_others03 varchar(50) default 'na',
	tag_others04 varchar(50) default 'na',
	tag_others05 varchar(50) default 'na',
	tag_nnnn_yn01 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn02 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn03 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn04 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn05 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	var_50_001 varchar(50),
	var_50_002 varchar(50),
	var_50_003 varchar(50),
	var_50_004 varchar(50),
	var_50_005 varchar(50),
	var_50_006 varchar(50),
	var_50_007 varchar(50),
	var_50_008 varchar(50),
	var_50_009 varchar(50),
	var_50_010 varchar(50),
	var_200_001 varchar(200),
	var_200_002 varchar(200),
	var_200_003 varchar(200),
	var_200_004 varchar(200),
	var_200_005 varchar(200),
	num_20_4_d_001 numeric(20,4) default 0,
	num_20_4_d_002 numeric(20,4) default 0,
	num_20_4_d_003 numeric(20,4) default 0,
	num_20_4_d_004 numeric(20,4) default 0,
	num_20_4_d_005 numeric(20,4) default 0,
	num_20_4_d_006 numeric(20,4) default 0,
	num_20_4_d_007 numeric(20,4) default 0,
	num_20_4_d_008 numeric(20,4) default 0,
	num_20_8_d_001 numeric(20,8) default 0,
	num_20_8_d_002 numeric(20,8) default 0,
	num_20_8_d_003 numeric(20,8) default 0,
	num_20_8_d_004 numeric(20,8) default 0,
	num_20_8_d_005 numeric(20,8) default 0,
	num_20_8_d_006 numeric(20,8) default 0,
	num_20_8_d_007 numeric(20,8) default 0,
	num_20_8_d_008 numeric(20,8) default 0,
	date_001 datetime,
	date_002 datetime,
	date_003 datetime,
	date_004 datetime,
	date_005 datetime,
	date_006 datetime,
	date_007 datetime,
	date_008 datetime,
	date_009 datetime,
	date_010 datetime,
	date_post datetime default GETDATE(),
	date_lastupdate datetime default GETDATE(),
	date_submit datetime,
	tag_void_yn varchar(5) default 'n',
	tag_active_yn varchar(5) default 'y',
	userid_cookie varchar(50)
)
GO

CREATE TABLE question_main
(
	idcode int identity(1,1) primary key,
	row_item_num int default 1,	
	uniquenum_pri varchar(50),
	uniquenum_sec varchar(50),
	uniquenum_uniq varchar(50),
	uniquenum_cnt int,
	dnum_auto varchar(50),
	dnum_reference varchar(50),
	dnum_master varchar(50),
	questionmain_unique varchar(50),
	questionmain_code varchar(50),	
	questionmain_desc_english nvarchar(max),
	questionmain_desc_vietnamese nvarchar(max),
	questionmain_desc_japanese nvarchar(max),
	questionmain_desc_chinese nvarchar(max),
	questionmain_desc_korean nvarchar(max),
	questionmain_desc_french nvarchar(max),
	questionmain_desc_german nvarchar(max),
	questionmain_desc_spanish nvarchar(max),
	questionmain_desc_lang01 nvarchar(max),
	questionmain_desc_lang02 nvarchar(max),
	questionmain_desc_lang03 nvarchar(max),
	questionmain_desc_memo nvarchar(max),
	notes_short nvarchar(500),	
	tag_deleted_yn varchar(5) default 'n',
	tag_table_usage varchar(50) default 'sys',
	tag_tab_type varchar(50),
	tag_questionmain_type varchar(50),
	tag_datasource varchar(500),
	notes_memo nvarchar(max),
	questionmaingrp_unique varchar(50),
	questionmaingrp_code varchar(50),
	questionmaingrp_desc nvarchar(200),
	questionmaincate_unique varchar(50),
	questionmaincate_code varchar(50),
	questionmaincate_desc nvarchar(200),
	questionmainclas_unique varchar(50),
	questionmainclas_code varchar(50),
	questionmainclas_desc nvarchar(200),
	party_unique varchar(50),
	party_code varchar(50),
	party_desc nvarchar(200),
	author_unique varchar(50),
	author_code varchar(50),
	author_desc nvarchar(200),
	dnum_image01 varchar(50),
	dnum_image02 varchar(50),
	dnum_image03 varchar(50),
	dnum_image04 varchar(50),
	dnum_image05 varchar(50),
	dnum_catelog01 varchar(50),
	dnum_catelog02 varchar(50),
	dnum_catelog03 varchar(50),
	dnum_catelog04 varchar(50),
	dnum_catelog05 varchar(50),
	tag_others01 varchar(50) default 'na',
	tag_others02 varchar(50) default 'na',
	tag_others03 varchar(50) default 'na',
	tag_others04 varchar(50) default 'na',
	tag_others05 varchar(50) default 'na',
	tag_nnnn_yn01 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn02 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn03 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn04 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn05 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	var_50_001 varchar(50),
	var_50_002 varchar(50),
	var_50_003 varchar(50),
	var_50_004 varchar(50),
	var_50_005 varchar(50),
	var_50_006 varchar(50),
	var_50_007 varchar(50),
	var_50_008 varchar(50),
	var_50_009 varchar(50),
	var_50_010 varchar(50),
	var_200_001 varchar(200),
	var_200_002 varchar(200),
	var_200_003 varchar(200),
	var_200_004 varchar(200),
	var_200_005 varchar(200),
	num_20_4_d_001 numeric(20,4) default 0,
	num_20_4_d_002 numeric(20,4) default 0,
	num_20_4_d_003 numeric(20,4) default 0,
	num_20_4_d_004 numeric(20,4) default 0,
	num_20_4_d_005 numeric(20,4) default 0,
	num_20_4_d_006 numeric(20,4) default 0,
	num_20_4_d_007 numeric(20,4) default 0,
	num_20_4_d_008 numeric(20,4) default 0,
	num_20_8_d_001 numeric(20,8) default 0,
	num_20_8_d_002 numeric(20,8) default 0,
	num_20_8_d_003 numeric(20,8) default 0,
	num_20_8_d_004 numeric(20,8) default 0,
	num_20_8_d_005 numeric(20,8) default 0,
	num_20_8_d_006 numeric(20,8) default 0,
	num_20_8_d_007 numeric(20,8) default 0,
	num_20_8_d_008 numeric(20,8) default 0,
	date_001 datetime,
	date_002 datetime,
	date_003 datetime,
	date_004 datetime,
	date_005 datetime,
	date_006 datetime,
	date_007 datetime,
	date_008 datetime,
	date_009 datetime,
	date_010 datetime,
	date_post datetime default GETDATE(),
	date_lastupdate datetime default GETDATE(),
	date_submit datetime,
	tag_void_yn varchar(5) default 'n',
	tag_active_yn varchar(5) default 'y',
	userid_cookie varchar(50)
)
GO

CREATE TABLE question_data
(
	idcode int identity(1,1) primary key,
	row_item_num int default 1,	
	uniquenum_pri varchar(50),
	uniquenum_sec varchar(50),
	uniquenum_uniq varchar(50),
	uniquenum_cnt int,
	dnum_auto varchar(50),
	dnum_reference varchar(50),
	dnum_master varchar(50),
	questiondata_unique varchar(50),
	questiondata_code varchar(50),	
	questiondata_desc_english nvarchar(max),
	questiondata_desc_vietnamese nvarchar(max),
	questiondata_desc_japanese nvarchar(max),
	questiondata_desc_chinese nvarchar(max),
	questiondata_desc_korean nvarchar(max),
	questiondata_desc_french nvarchar(max),
	questiondata_desc_german nvarchar(max),
	questiondata_desc_spanish nvarchar(max),
	questiondata_desc_lang01 nvarchar(max),
	questiondata_desc_lang02 nvarchar(max),
	questiondata_desc_lang03 nvarchar(max),
	questiondata_desc_memo nvarchar(max),
	notes_short nvarchar(500),	
	tag_deleted_yn varchar(5) default 'n',
	tag_table_usage varchar(50) default 'sys',
	tag_tab_type varchar(50),
	tag_questiondata_type varchar(50),
	tag_datasource varchar(500),
	notes_memo nvarchar(max),
	questiondatagrp_unique varchar(50),
	questiondatagrp_code varchar(50),
	questiondatagrp_desc nvarchar(200),
	questiondatacate_unique varchar(50),
	questiondatacate_code varchar(50),
	questiondatacate_desc nvarchar(200),
	questiondataclas_unique varchar(50),
	questiondataclas_code varchar(50),
	questiondataclas_desc nvarchar(200),
	party_unique varchar(50),
	party_code varchar(50),
	party_desc nvarchar(200),
	author_unique varchar(50),
	author_code varchar(50),
	author_desc nvarchar(200),
	dnum_image01 varchar(50),
	dnum_image02 varchar(50),
	dnum_image03 varchar(50),
	dnum_image04 varchar(50),
	dnum_image05 varchar(50),
	dnum_catelog01 varchar(50),
	dnum_catelog02 varchar(50),
	dnum_catelog03 varchar(50),
	dnum_catelog04 varchar(50),
	dnum_catelog05 varchar(50),
	tag_others01 varchar(50) default 'na',
	tag_others02 varchar(50) default 'na',
	tag_others03 varchar(50) default 'na',
	tag_others04 varchar(50) default 'na',
	tag_others05 varchar(50) default 'na',
	tag_nnnn_yn01 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn02 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn03 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn04 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn05 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	var_50_001 varchar(50),
	var_50_002 varchar(50),
	var_50_003 varchar(50),
	var_50_004 varchar(50),
	var_50_005 varchar(50),
	var_50_006 varchar(50),
	var_50_007 varchar(50),
	var_50_008 varchar(50),
	var_50_009 varchar(50),
	var_50_010 varchar(50),
	var_200_001 varchar(200),
	var_200_002 varchar(200),
	var_200_003 varchar(200),
	var_200_004 varchar(200),
	var_200_005 varchar(200),
	num_20_4_d_001 numeric(20,4) default 0,
	num_20_4_d_002 numeric(20,4) default 0,
	num_20_4_d_003 numeric(20,4) default 0,
	num_20_4_d_004 numeric(20,4) default 0,
	num_20_4_d_005 numeric(20,4) default 0,
	num_20_4_d_006 numeric(20,4) default 0,
	num_20_4_d_007 numeric(20,4) default 0,
	num_20_4_d_008 numeric(20,4) default 0,
	num_20_8_d_001 numeric(20,8) default 0,
	num_20_8_d_002 numeric(20,8) default 0,
	num_20_8_d_003 numeric(20,8) default 0,
	num_20_8_d_004 numeric(20,8) default 0,
	num_20_8_d_005 numeric(20,8) default 0,
	num_20_8_d_006 numeric(20,8) default 0,
	num_20_8_d_007 numeric(20,8) default 0,
	num_20_8_d_008 numeric(20,8) default 0,
	date_001 datetime,
	date_002 datetime,
	date_003 datetime,
	date_004 datetime,
	date_005 datetime,
	date_006 datetime,
	date_007 datetime,
	date_008 datetime,
	date_009 datetime,
	date_010 datetime,
	date_post datetime default GETDATE(),
	date_lastupdate datetime default GETDATE(),
	date_submit datetime,
	tag_void_yn varchar(5) default 'n',
	tag_active_yn varchar(5) default 'y',
	userid_cookie varchar(50)
)
GO

CREATE TABLE user_main
(
	idcode int identity(1,1) primary key,
	row_item_num int default 1,	
	uniquenum_pri varchar(50),
	uniquenum_sec varchar(50),
	uniquenum_uniq varchar(50),
	uniquenum_cnt int,
	dnum_auto varchar(50),
	dnum_reference varchar(50),
	dnum_master varchar(50),
	user_unique varchar(50),
	user_code varchar(50),	
	user_fullname nvarchar(max),	
	user_desc_memo nvarchar(max),
	addr_main_line nvarchar(max),
	telnum_main_01 varchar(30),
	telnum_main_02 varchar(30),
	faxnum_main_01 varchar(30),
	faxnum_main_02 varchar(30),
	email_main_01 varchar(50),
	email_main_02 varchar(50),
	nationality_code varchar(50),
	nationality_desc varchar(50),
	idcard_num varchar(50),
	passport_num varchar(50),
	date_birth datetime,
	notes_short nvarchar(500),
	personnel_remarks nvarchar(200),	
	tag_deleted_yn varchar(5) default 'n',
	tag_table_usage varchar(50) default 'sys',
	tag_tab_type varchar(50),
	tag_user_type varchar(50),
	tag_datasource varchar(500),
	notes_memo nvarchar(max),
	usergrp_unique varchar(50),
	usergrp_code varchar(50),
	usergrp_desc nvarchar(200),
	usercate_unique varchar(50),
	usercate_code varchar(50),
	usercate_desc nvarchar(200),
	userclas_unique varchar(50),
	userclas_code varchar(50),
	userclas_desc nvarchar(200),
	party_unique varchar(50),
	party_code varchar(50),
	party_desc nvarchar(200),	
	dnum_image01 varchar(50),
	dnum_image02 varchar(50),
	dnum_image03 varchar(50),
	dnum_image04 varchar(50),
	dnum_image05 varchar(50),
	dnum_catelog01 varchar(50),
	dnum_catelog02 varchar(50),
	dnum_catelog03 varchar(50),
	dnum_catelog04 varchar(50),
	dnum_catelog05 varchar(50),
	tag_others01 varchar(50) default 'na',
	tag_others02 varchar(50) default 'na',
	tag_others03 varchar(50) default 'na',
	tag_others04 varchar(50) default 'na',
	tag_others05 varchar(50) default 'na',
	tag_nnnn_yn01 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn02 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn03 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn04 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn05 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	var_50_001 varchar(50),
	var_50_002 varchar(50),
	var_50_003 varchar(50),
	var_50_004 varchar(50),
	var_50_005 varchar(50),	
	var_200_001 varchar(200),
	var_200_002 varchar(200),
	var_200_003 varchar(200),
	var_200_004 varchar(200),
	var_200_005 varchar(200),
	num_20_4_d_001 numeric(20,4) default 0,
	num_20_4_d_002 numeric(20,4) default 0,
	num_20_4_d_003 numeric(20,4) default 0,
	num_20_4_d_004 numeric(20,4) default 0,	
	num_20_8_d_001 numeric(20,8) default 0,
	num_20_8_d_002 numeric(20,8) default 0,
	num_20_8_d_003 numeric(20,8) default 0,
	num_20_8_d_004 numeric(20,8) default 0,	
	date_001 datetime,
	date_002 datetime,
	date_003 datetime,
	date_004 datetime,	
	date_post datetime default GETDATE(),
	date_lastupdate datetime default GETDATE(),
	date_submit datetime,
	tag_void_yn varchar(5) default 'n',
	tag_active_yn varchar(5) default 'y',
	userid_cookie varchar(50)
)
GO


CREATE TABLE user_data
(
	idcode int identity(1,1) primary key,
	row_item_num int default 1,	
	uniquenum_pri varchar(50),
	uniquenum_sec varchar(50),
	uniquenum_uniq varchar(50),
	uniquenum_cnt int,
	dnum_auto varchar(50),
	dnum_reference varchar(50),
	dnum_master varchar(50),
	userdata_unique varchar(50),
	userdata_code varchar(50),	
	userdata_desc nvarchar(max),	
	userdata_memo nvarchar(max),
	addr_main_line nvarchar(max),
	telnum_main_01 varchar(30),
	telnum_main_02 varchar(30),
	faxnum_main_01 varchar(30),
	faxnum_main_02 varchar(30),
	email_main_01 varchar(50),
	email_main_02 varchar(50),
	nationality_code varchar(50),
	nationality_desc varchar(50),
	idcard_num varchar(50),
	passport_num varchar(50),
	date_birth datetime,
	notes_short nvarchar(500),
	personnel_remarks nvarchar(200),	
	tag_deleted_yn varchar(5) default 'n',
	tag_table_usage varchar(50) default 'sys',
	tag_tab_type varchar(50),
	tag_user_type varchar(50),
	tag_datasource varchar(500),
	notes_memo nvarchar(max),	
	party_unique varchar(50),
	party_code varchar(50),
	party_desc nvarchar(200),	
	dnum_image01 varchar(50),
	dnum_image02 varchar(50),
	dnum_image03 varchar(50),
	dnum_image04 varchar(50),
	dnum_image05 varchar(50),
	dnum_catelog01 varchar(50),
	dnum_catelog02 varchar(50),
	dnum_catelog03 varchar(50),
	dnum_catelog04 varchar(50),
	dnum_catelog05 varchar(50),
	tag_others01 varchar(50) default 'na',
	tag_others02 varchar(50) default 'na',
	tag_others03 varchar(50) default 'na',
	tag_others04 varchar(50) default 'na',
	tag_others05 varchar(50) default 'na',
	tag_nnnn_yn01 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn02 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn03 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn04 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn05 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	var_50_001 varchar(50),
	var_50_002 varchar(50),
	var_50_003 varchar(50),
	var_50_004 varchar(50),
	var_50_005 varchar(50),	
	var_50_006 varchar(50),
	var_50_007 varchar(50),
	var_50_008 varchar(50),
	var_50_009 varchar(50),
	var_50_010 varchar(50),
	var_200_001 varchar(200),
	var_200_002 varchar(200),
	var_200_003 varchar(200),
	var_200_004 varchar(200),
	var_200_005 varchar(200),
	var_200_006 varchar(200),
	var_200_007 varchar(200),
	var_200_008 varchar(200),
	var_200_009 varchar(200),
	var_200_010 varchar(200),
	num_20_4_d_001 numeric(20,4) default 0,
	num_20_4_d_002 numeric(20,4) default 0,
	num_20_4_d_003 numeric(20,4) default 0,
	num_20_4_d_004 numeric(20,4) default 0,
	num_20_4_d_005 numeric(20,4) default 0,
	num_20_8_d_001 numeric(20,8) default 0,
	num_20_8_d_002 numeric(20,8) default 0,
	num_20_8_d_003 numeric(20,8) default 0,
	num_20_8_d_004 numeric(20,8) default 0,
	num_20_8_d_005 numeric(20,8) default 0,
	date_001 datetime,
	date_002 datetime,
	date_003 datetime,
	date_004 datetime,
	date_005 datetime,
	date_006 datetime,
	date_007 datetime,
	date_008 datetime,
	date_009 datetime,
	date_010 datetime,
	date_post datetime default GETDATE(),
	date_lastupdate datetime default GETDATE(),
	date_submit datetime,
	tag_void_yn varchar(5) default 'n',
	tag_active_yn varchar(5) default 'y',
	userid_cookie varchar(50)
)
GO


CREATE TABLE set_codes_main
(
	idcode int identity(1,1) primary key,
	row_item_num int default 1,	
	uniquenum_pri varchar(50),
	uniquenum_sec varchar(50),
	uniquenum_uniq varchar(50),
	uniquenum_cnt int,
	dnum_auto varchar(50),
	dnum_reference varchar(50),
	dnum_master varchar(50),
	setgen_unique varchar(50),
	setgen_code varchar(50),	
	desc_english nvarchar(max),
	desc_vietnamese nvarchar(max),
	desc_japanese nvarchar(max),
	desc_chinese nvarchar(max),
	desc_korean nvarchar(max),
	desc_french nvarchar(max),
	desc_german nvarchar(max),
	desc_spanish nvarchar(max),
	desc_lang01 nvarchar(max),
	desc_lang02 nvarchar(max),
	desc_lang03 nvarchar(max),
	desc_memo nvarchar(max),
	notes_short nvarchar(500),
	setgen_remarks nvarchar(200),	
	tag_deleted_yn varchar(5) default 'n',
	tag_table_usage varchar(50) default 'sys',
	tag_tab_type varchar(50),
	tag_gencode_type varchar(50),
	tag_set_as_default_yn varchar(3),
	tag_datasource varchar(500),
	notes_memo nvarchar(max),
	gencodegrp_unique varchar(50),
	gencodegrp_code varchar(50),
	gencodegrp_desc nvarchar(200),
	gencodecate_unique varchar(50),
	gencodecate_code varchar(50),
	gencodecate_desc nvarchar(200),
	gencodeclas_unique varchar(50),
	gencodeclas_code varchar(50),
	gencodeclas_desc nvarchar(200),
	party_unique varchar(50),
	party_code varchar(50),
	party_desc nvarchar(200),	
	dnum_image01 varchar(50),
	dnum_image02 varchar(50),
	dnum_image03 varchar(50),
	dnum_image04 varchar(50),
	dnum_image05 varchar(50),
	dnum_catelog01 varchar(50),
	dnum_catelog02 varchar(50),
	dnum_catelog03 varchar(50),
	dnum_catelog04 varchar(50),
	dnum_catelog05 varchar(50),
	tag_others01 varchar(50) default 'na',
	tag_others02 varchar(50) default 'na',
	tag_others03 varchar(50) default 'na',
	tag_others04 varchar(50) default 'na',
	tag_others05 varchar(50) default 'na',
	tag_nnnn_yn01 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn02 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn03 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn04 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn05 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	var_50_001 varchar(50),
	var_50_002 varchar(50),
	var_50_003 varchar(50),
	var_50_004 varchar(50),
	var_50_005 varchar(50),	
	var_200_001 varchar(200),
	var_200_002 varchar(200),
	var_200_003 varchar(200),
	var_200_004 varchar(200),
	var_200_005 varchar(200),
	num_20_4_d_001 numeric(20,4) default 0,
	num_20_4_d_002 numeric(20,4) default 0,
	num_20_4_d_003 numeric(20,4) default 0,
	num_20_4_d_004 numeric(20,4) default 0,	
	num_20_8_d_001 numeric(20,8) default 0,
	num_20_8_d_002 numeric(20,8) default 0,
	num_20_8_d_003 numeric(20,8) default 0,
	num_20_8_d_004 numeric(20,8) default 0,	
	date_001 datetime,
	date_002 datetime,
	date_003 datetime,
	date_004 datetime,	
	date_post datetime default GETDATE(),
	date_lastupdate datetime default GETDATE(),
	date_submit datetime,
	tag_void_yn varchar(5) default 'n',
	tag_active_yn varchar(5) default 'y',
	userid_cookie varchar(50)
)
GO

CREATE TABLE sys_activity_main
(
	idcode int identity(1,1) primary key,
	row_item_num int default 1,	
	uniquenum_pri varchar(50),
	uniquenum_sec varchar(50),
	uniquenum_uniq varchar(50),
	uniquenum_cnt int,
	dnum_auto varchar(50),
	dnum_reference varchar(50),
	dnum_master varchar(50),
	activity_unique varchar(50),
	activity_code varchar(50),	
	desc_english nvarchar(max),
	desc_vietnamese nvarchar(max),
	desc_japanese nvarchar(max),
	desc_chinese nvarchar(max),
	desc_korean nvarchar(max),
	desc_french nvarchar(max),
	desc_german nvarchar(max),
	desc_spanish nvarchar(max),
	desc_lang01 nvarchar(max),
	desc_lang02 nvarchar(max),
	desc_lang03 nvarchar(max),
	desc_memo nvarchar(max),
	notes_short nvarchar(500),
	activity_remarks nvarchar(200),	
	tag_deleted_yn varchar(5) default 'n',
	tag_table_usage varchar(50) default 'sys',
	tag_tab_type varchar(50),
	tag_activity_type varchar(50),	
	tag_datasource varchar(500),
	notes_memo nvarchar(max),
	activitygrp_unique varchar(50),
	activitygrp_code varchar(50),
	activitygrp_desc nvarchar(200),
	activitycate_unique varchar(50),
	activitycate_code varchar(50),
	activitycate_desc nvarchar(200),
	activityclas_unique varchar(50),
	activityclas_code varchar(50),
	activityclas_desc nvarchar(200),
	party_unique varchar(50),
	party_code varchar(50),
	party_desc nvarchar(200),	
	dnum_image01 varchar(50),
	dnum_image02 varchar(50),
	dnum_image03 varchar(50),
	dnum_image04 varchar(50),
	dnum_image05 varchar(50),
	dnum_catelog01 varchar(50),
	dnum_catelog02 varchar(50),
	dnum_catelog03 varchar(50),
	dnum_catelog04 varchar(50),
	dnum_catelog05 varchar(50),
	tag_others01 varchar(50) default 'na',
	tag_others02 varchar(50) default 'na',
	tag_others03 varchar(50) default 'na',
	tag_others04 varchar(50) default 'na',
	tag_others05 varchar(50) default 'na',
	tag_nnnn_yn01 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn02 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn03 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn04 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn05 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	var_50_001 varchar(50),
	var_50_002 varchar(50),
	var_50_003 varchar(50),
	var_50_004 varchar(50),
	var_50_005 varchar(50),	
	var_200_001 varchar(200),
	var_200_002 varchar(200),
	var_200_003 varchar(200),
	var_200_004 varchar(200),
	var_200_005 varchar(200),
	num_20_4_d_001 numeric(20,4) default 0,
	num_20_4_d_002 numeric(20,4) default 0,
	num_20_4_d_003 numeric(20,4) default 0,
	num_20_4_d_004 numeric(20,4) default 0,	
	num_20_8_d_001 numeric(20,8) default 0,
	num_20_8_d_002 numeric(20,8) default 0,
	num_20_8_d_003 numeric(20,8) default 0,
	num_20_8_d_004 numeric(20,8) default 0,	
	date_001 datetime,
	date_002 datetime,
	date_003 datetime,
	date_004 datetime,
	date_005 datetime,
	date_post datetime default GETDATE(),
	date_lastupdate datetime default GETDATE(),
	date_submit datetime,
	tag_void_yn varchar(5) default 'n',
	tag_active_yn varchar(5) default 'y',
	userid_cookie varchar(50)
)

CREATE TABLE sys_activity_data
(
	idcode int identity(1,1) primary key,
	row_item_num int default 1,	
	uniquenum_pri varchar(50),
	uniquenum_sec varchar(50),
	uniquenum_uniq varchar(50),
	uniquenum_cnt int,
	dnum_auto varchar(50),
	dnum_reference varchar(50),
	dnum_master varchar(50),
	activitydata_unique varchar(50),
	activitydata_code varchar(50),	
	desc_english nvarchar(max),
	desc_vietnamese nvarchar(max),
	desc_japanese nvarchar(max),
	desc_chinese nvarchar(max),
	desc_korean nvarchar(max),
	desc_french nvarchar(max),
	desc_german nvarchar(max),
	desc_spanish nvarchar(max),
	desc_lang01 nvarchar(max),
	desc_lang02 nvarchar(max),
	desc_lang03 nvarchar(max),
	desc_memo nvarchar(max),
	notes_short nvarchar(500),
	activitydata_remarks nvarchar(200),	
	tag_deleted_yn varchar(5) default 'n',
	tag_table_usage varchar(50) default 'sys',
	tag_tab_type varchar(50),
	tag_activitydata_type varchar(50),	
	tag_datasource varchar(500),
	notes_memo nvarchar(max),
	activitydatagrp_unique varchar(50),
	activitydatagrp_code varchar(50),
	activitydatagrp_desc nvarchar(200),
	activitydatacate_unique varchar(50),
	activitydatacate_code varchar(50),
	activitydatacate_desc nvarchar(200),
	activitydataclas_unique varchar(50),
	activitydataclas_code varchar(50),
	activitydataclas_desc nvarchar(200),
	party_unique varchar(50),
	party_code varchar(50),
	party_desc nvarchar(200),	
	dnum_image01 varchar(50),
	dnum_image02 varchar(50),
	dnum_image03 varchar(50),
	dnum_image04 varchar(50),
	dnum_image05 varchar(50),
	dnum_catelog01 varchar(50),
	dnum_catelog02 varchar(50),
	dnum_catelog03 varchar(50),
	dnum_catelog04 varchar(50),
	dnum_catelog05 varchar(50),
	tag_others01 varchar(50) default 'na',
	tag_others02 varchar(50) default 'na',
	tag_others03 varchar(50) default 'na',
	tag_others04 varchar(50) default 'na',
	tag_others05 varchar(50) default 'na',
	tag_nnnn_yn01 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn02 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn03 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn04 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	tag_nnnn_yn05 varchar(50) default 'nnnnnnnnnnnnnnnnnnnn',
	var_50_001 varchar(50),
	var_50_002 varchar(50),
	var_50_003 varchar(50),
	var_50_004 varchar(50),
	var_50_005 varchar(50),	
	var_200_001 varchar(200),
	var_200_002 varchar(200),
	var_200_003 varchar(200),
	var_200_004 varchar(200),
	var_200_005 varchar(200),
	num_20_4_d_001 numeric(20,4) default 0,
	num_20_4_d_002 numeric(20,4) default 0,
	num_20_4_d_003 numeric(20,4) default 0,
	num_20_4_d_004 numeric(20,4) default 0,	
	num_20_8_d_001 numeric(20,8) default 0,
	num_20_8_d_002 numeric(20,8) default 0,
	num_20_8_d_003 numeric(20,8) default 0,
	num_20_8_d_004 numeric(20,8) default 0,	
	date_001 datetime,
	date_002 datetime,
	date_003 datetime,
	date_004 datetime,
	date_005 datetime,
	date_post datetime default GETDATE(),
	date_lastupdate datetime default GETDATE(),
	date_submit datetime,
	tag_void_yn varchar(5) default 'n',
	tag_active_yn varchar(5) default 'y',
	userid_cookie varchar(50)
)